Re: How to get of the list ?

2002-02-13 Thread Steen Rabol
- Original Message - From: <[EMAIL PROTECTED]> To: "Steen Rabol" <[EMAIL PROTECTED]> Sent: Wednesday, February 13, 2002 12:10 PM Subject: Re: How to get of the list ? > Your message cannot be posted because it appears to be either spam or > simply off topic

Re: Is this possible in one SQL statement

2002-01-31 Thread Steen Rabol
quot;Rick Emery" <[EMAIL PROTECTED]> To: "'Steen Rabol'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 31, 2002 9:35 PM Subject: RE: Is this possible in one SQL statement > Please restate the following more completely. I think some ty

Is this possible in one SQL statement

2002-01-31 Thread Steen Rabol
Is this possible in a single select statement ? table A id (Unique), a_field1,a_field2,a_field3 table B id(NOT unique), b_field1 Id in table B is a ref to id in table A Now i would like to select all the id's from table A which have records i table B where b_field1 is 1 and b_field2 is

Saving a query

2001-01-17 Thread Steen Rabol
Hi Is it possible to save a advanced query in the database and the call it from eg. php, like you can in Access ? Thanks in advance. Best Steen - Before posting, please check: http://www.mysql.com/manual.php (the manual)