Re: Query Help

[Mirko <suppressed>]

I think you can't
If you want this why is this table structure? Details shold be as columns 
nos as records in separate table - just to lose time ?


On Tue, 11 Feb 2003 13:13:31 +0000, Jeff Snoxell <suppressed> 
wrote:

> 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 <suppressed>
> To unsubscribe, e-mail <mysql-unsubscribe- 
> suppressed>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




---------------------------------------------------------------------
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 <suppressed>
To unsubscribe, e-mail <suppressed>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php