Query Help

[Jeff Snoxell]

Hi,

How can I write a MySQL query to grab single lines of the form:

ColumnNames: EnquiryID, Name, Address, Detail1, Detail2, Detail3, Detail4

From two joined tables:

Tbl1: Enquiries
--------------
ID
Name
Address
Etc
----------------

Tb12: Details
----------------
ID
EnquiryID
Detail
Etc
----------------

There is an imposed maximum number of details per enquiry (say 4 for this example).

Many thanks,


Jeff


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php