Supplier ID List

Jun 30, 2006 2 Replies
N

I know that I have seen this SQL command somewhere on this Newsgroup. But for some reason I cannot find it. I need a SQL Query that tells me all of my suppliers what there SupplierID is. For some reason I cannot produce the right results. I just need to match up the Suppliers names with their SupplierID. Any help would be greatly appreciated.



Thanks, Neil



Vote
Twitter Facebook LinkedIn
M

Try,

Select * from supplier

Mihir Diviasoft, Inc

Vote
Twitter Facebook LinkedIn
N

Thank you very much. That worked great. I was making it to hard by just wanting to get the supplier name and ID. Thanks for the quick reply.

Neil

"Mihir Shah" wrote:

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required