Soumen-Roy
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.CurrentStic kerNo
from AMCEntry
inner join StickerDetails
on AMCEntry.StickerNo=Sticker Details.Ac tStickerNo
order by AMCEntry.PONo desc
my question is, which one is suggested to use and why?
Thanking you,
Soumen
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.CurrentStic
from AMCEntry
inner join StickerDetails
on AMCEntry.StickerNo=Sticker
order by AMCEntry.PONo desc
my question is, which one is suggested to use and why?
Thanking you,
Soumen
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER