Please disregard, I think that I figured it out.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Can you perhaps post the structure of your tables? That would make it
easier to help (at least for me)
On Thu, 2002-10-10 at 15:40, Pablo Oliva wrote:
> I have 2 tables, one with job ad information, and a second one with the
> locations that this ad applies to.
>
> When a person queries the jo
I have 2 tables, one with job ad information, and a second one with the
locations that this ad applies to.
When a person queries the job ad table with their criteria, I would also
have to query the location table to see if the location that they chose
applies to this ad. I am not sure how to co
Alsén" <[EMAIL PROTECTED]>
To: "PHP" <[EMAIL PROTECTED]>
Sent: Tuesday, December 11, 2001 4:09 PM
Subject: [PHP] Help with mysql query
> Even if this isn´t a mysql forum i hope to get some help on this:
>
> I have a table with 5 columns (named one to five) which con
Even if this isn´t a mysql forum i hope to get some help on this:
I have a table with 5 columns (named one to five) which contains numerical
values between 1 and 10.
I am trying to construct a query that gives me the count of the
representation of each numerical value (ie how many fives that are
"Christian Dechery" <[EMAIL PROTECTED]> wrote:
> I have a table A and a table B... I want all occurences from A there are
> not in B...
>
> in ANSI SQL... it's nothing more than:
>
> select a.id, a.name from table_a a, table_b b where a.id NOT IN (select id
> from table_b)
>
> and that's it... but
I'm having trouble puting up a query in Mysql because of his lack of SQL
syntax.
I have a table A and a table B... I want all occurences from A there are
not in B...
in ANSI SQL... it's nothing more than:
select a.id, a.name from table_a a, table_b b where a.id NOT IN (select id
from table_b
7 matches
Mail list logo
