>
> -ms
>
>
>
>
> -Original Message-
> From: Michael Shulman [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 02, 2003 11:38 AM
> To: 'John Hoskins'
> Cc: '[EMAIL PROTECTED]'
> Subject: RE: select help
>
> No problem. Use
os_table os, solutions_table solutions
> -> where os.os_id = solutions.os_code
> -> and os.os_id = 8;
>
> -ms
>
>
> -Original Message-
> From: John Hoskins [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 02, 2003 10:41 AM
> To: [EMAIL PROTECTED]
&g
Please consider the following two tables:
mysql> select * from os_table;
+---+--+
| os_id | os_name |
+---+--+
| 1 | mac os |
| 2 | win 95 |
| 4 | win 98 |
| 8 | win nt |
|16 | win 2000 |
|32 | win me |
|64 | xp home |
| 128 | xp p
Probably a simple query but, I need to find select a field with data that
exists in one table but does not exist in a field in another table.
example:
table1.name table2.name
---
bob john
susan
