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-01-09 : 11:07:56
|
Leonard writes "I posted this question on a few newsgroups but I did not receive a relly good answers.
I have two tables:
tblStoreCreditCards
ID
StoreID
CreditCardID
tblCreditCardTypes
CreditCardID
CardType
The tables have a relationship on the CreditCardID Field. What I need to do is to display all values from tblCreditCardTypes.CardType that do not appear in the tblStoreCreditCards. The tricky part is that I need to have StoreID displayed for each result. I need that to later filter on that value in my ASP script. It also needs to be compatible with both SQL Server and Access so it needs to use simple outer, inner or other simple syntax.
Bellow is a sample query output that I want.
StoreID..CreditCardID..CardType
-----------------------------------------
1589.........3.............Amex
1589.........4.............Discover
2458.........4.............Discover
3458.........2.............Master Card
3458.........3.............Amex
3458.........4.............Discover
Thanks for any help
Leonard" |
|
|
|
|
|
Show unmached records with values not existing in the table.