Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

query help plz

Status
Not open for further replies.
whtisthat

whtisthat

Technical User
Mar 27, 2004
12
US
I need list of all vendors. with this I am getting some duplicate any help plz
SELECT
distinct pv.vendor_id,
pv.vendor_name ,
pvs.address_line1,
pvs.address_line2,
pvs.address_line3,
pvs.city ,
pvs. state,
pvs.zip
FROM po.po_vendors pv , apps.po_vendor_sites pvs
WHERE pv.vendor_id = pvs.vendor_id
and pvs.pay_site_flag = 'Y'
and pv.enabled_flag = 'Y'
and pv.VENDOR_TYPE_LOOKUP_CODE = 'VENDOR'
order by 2
 
Status
Not open for further replies.

Similar threads

bcar72
  • Locked
  • Question
oracle configurator and java help
Replies
0
Views
309
bcar72
bcar72
erprider
  • Locked
  • Question
ACCPAC F1 Help
Replies
1
Views
314
erprider
erprider
LostinJDE
  • Locked
  • Question
JDE World Query
Replies
0
Views
59
LostinJDE
LostinJDE
gk4u
  • Locked
  • Question
How to Kill SQL Query
Replies
0
Views
63
gk4u
gk4u
whtisthat
  • Locked
  • Question
PO Update Script Gurus Plz
Replies
0
Views
66
whtisthat
whtisthat

Part and Inventory Search

Sponsor

Back
Top