Supplier ID List

Posted by nt8378 on June 30, 2006, 2:44 pm

Please log in for more thread options

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

Posted by Mihir Shah on June 30, 2006, 3:05 pm

Please log in for more thread options

Try,

Select * from supplier

Mihir
Diviasoft, Inc

>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

Posted by nt8378 on June 30, 2006, 4:08 pm

Please log in for more thread options

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:

> Try,

> Select * from supplier

> Mihir

> Diviasoft, Inc

> >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

> >