Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-05 : 00:36:44
|
Budi Sentosa writes "Dear,
Sorry may be this is a stupid question but I can't fiqure it out.
Example :
I have 2 table like this
TABLE 1
ID color
abc standard
bcd standard
cde standard
TABLE2
AutoID/ID/color
1/abc/red
2/abc/yellow
3/cde/white
4/cde/black
And i want to make a query that result :
abc/standard
abc/red
abc/yellow
bcd/standard
cde/white
cde/black
Please help me
Regards
Budi" |
|
|
|
|
|
query Question