Link to home
Start Free TrialLog in
Avatar of Soumen-Roy
Soumen-RoyFlag for India

asked on

Optimal SQL Query

Hallo Experts,

i am getting the same result with the following two sql s

1.
---

select a.PONo, a.AMCBy, b.CurrentStickerNo
from AMCEntry a, StickerDetails b where a.StickerNo=b.ActStickerNo
order by a.PONo desc

AND

2.
---
select AMCEntry.PONo, AMCEntry.AMCBy, StickerDetails.CurrentStickerNo
from AMCEntry
inner join StickerDetails
on AMCEntry.StickerNo=StickerDetails.ActStickerNo
order by AMCEntry.PONo desc


my question is, which one is suggested to use and why?

Thanking you,
Soumen
SOLUTION
Avatar of OMC2000
OMC2000
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Soumen-Roy

ASKER

Thanx