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
Try,
Select * from supplier
Mihir Diviasoft, Inc
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:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.