Forums :: Advanced Search

DwZone Forum
Welcome to the DwZone-it Forum

FAQ

Memberlist

Usergroups

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 Per page Messages Since

Messages 151 to 160 of 282 (Total: 122)

First | Prev | Next | Last

Subject

Author

Date

Re:Two fields with the same name problem

[email protected]

11:32 26 May 2007

Re:Two fields with the same name problem

gianluigi

1:14 27 May 2007

Hi,

It's the same for all the db, tableName.Fieldname

SELECT Ticket_No, Registration_No, Issued_date, Vehicle_make, Vehicle_colour, Issued_by, Reason, Paid_Date, Ticket_Status, p.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

OR

SELECT Ticket_No, Registration_No, Issued_date, Vehicle_make, Vehicle_colour, Issued_by, Reason, Paid_Date, Ticket_Status, c.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

Gianluigi