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     I have the following SQL statement: SELECT * FROM Tickets p JOIN Customer c ON p.Cust_Num = c.Cust_Num WHERE p.Ticket_No = '"& strdummy &"' The problem is both tables have a field named "notes". I am trying to display the notes field from Tickets but when I select the Ticket/notes field the Customer/notes field is selected. Cheers SteveW          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      Re:Two fields with the same name problem    gianluigi   11:27 26 May 2007   Last Visit: Saturday 2 Nov, 2024 0:37 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