DwZone Forum Welcome to the DwZone-it Forum     FAQ   Search   Memberlist   Usergroups       Register -->   Login   Advanced Search   DwZone Forum Index -> Advanced Search Moderators: Administrators, Moderators  Mark all topics read Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes. Search for  View  Normal Expanded Dynamic Dynamic Memory Threaded Threaded Expanded Threaded Dynamic    Per page  102550    Messages Since  Last Visit Last Day Last Week Last Month Last 6 Months Last Year All Messages 141 to 150 of 282 (Total: 122) First |  Prev |  Next |  Last    Subject Author Date      Re:What works with what?    gianluigi   14:12 1 Aug 2007      Re:What works with what?    [email protected]   14:15 1 Aug 2007      query Wizard    [email protected]   17:46 21 Jul 2007      Re:query Wizard    gianluigi   0:03 22 Jul 2007      Re:query Wizard    [email protected]   14:07 25 Jul 2007      Re:query Wizard    gianluigi   5:24 28 Jul 2007      Two fields with the same name problem    [email protected]   8:07 13 Apr 2007      Re:Two fields with the same name problem    gianluigi   10:06 13 Apr 2007       Re:Two fields with the same name problem    [email protected]   10:41 26 May 2007     I am using the following: SELECT Ticket_No, Registration_No, Issued_date, Vehicle_make, Vehicle_colour, Issued_by, Reason, Paid_Date, Ticket_Status FROM Tickets p JOIN Customer c ON p.Cust_Num = c.Cust_Num WHERE p.Location_Code = '" & strloc3 &"' ORDER BY Ticket_No DESC If I add "notes" or "notes as notes_2" ie SELECT Ticket_No, Registration_No, Issued_date, Vehicle_make, Vehicle_colour, Issued_by, Reason, Paid_Date, Ticket_Status, notes as Notes_2 FROM Tickets p JOIN Customer c ON p.Cust_Num = c.Cust_Num WHERE p.Location_Code = '" & strloc3 &"' ORDER BY Ticket_No DESC I get an error when testing saying Coloumn notes in field is ambigious Any help appreciated Cheers          Re:Two fields with the same name problem    gianluigi   11:27 26 May 2007   Last Visit: Saturday 2 Nov, 2024 0:32 am First |  Prev |  Next |  Last    Login Username:  Password:   Log me on automatically each visit:   Read Message   Unread message Read message [popular]   Unread message [popular] Read message [locked]   Unread message [locked] All times are GMT-1 Jump to:  Select a forum    Php Extensions --------------------  » Advanced Form Controls  » Advanced Image Gallery  » Advanced Mail  » Advanced Search  » Ajax DataGrid  » Ajax loader  » Boolean Update  » Dynamic Captcha Image  » Dynamic Chart  » Dynamic Image  » Form Validator  » Google Maps  » HTML to PDF  » Import/Export Tools  » Multi Column Combo  » Multiple file upload  » Multiple Record  » Other extensions  » PayPal IPN  » Query Manager and Recordset Wizard  » Recordset Paging  » Server Side Validation  » Shopping Cart  » Site Search Engine  » TreeView  » Two tables manager  » Upload and resize  » WYSIWYG Html Editor  Asp Extensions --------------------  » Advanced Form Controls  » Advanced Image Gallery  » Advanced Search  » Advanced Mail  » Ajax DataGrid  » Ajax loader  » Asp TreeView  » Asp Upload and Resize  » Boolean Update  » Dynamic Captcha Image  » Dynamic Chart  » Dynamic Image  » Form Validator  » Google Maps  » HTML to PDF  » Import/Export Tools  » Multi Column Combo  » Multiple file upload  » Multiple Record  » Other extensions  » PayPal IPN  » Query Manager and Recordset Wizard  » Recordset Paging  » Routing Map24  » Server Side Validation  » Shopping Cart  » Site Search Engine  » Two tables manager  » WYSIWYG Html Editor