LCKB › ** OLD LCKB DATABASE ** › Guides & Help Section › Help & Support › Ep2 Support › Solved Topics v
subselect

Linear Mode
subselect
Wizatek Offline
Posting Freak
*****
Posts: 768
Threads: 40
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: May 2011
Reputation: 0
#2
09-18-2013, 03:49 PM

Sure thats possible

 

 

SELECT
s.a_keeper_idx as npcid,
n.a_name_usa as npcname,
i.a_name_usa as itemname,
i.a_price

FROM
t_shopitem s,
t_item i,
t_npc n

WHERE
s.a_item_idx = i.a_index

AND
n.a_index = s.a_keeper_idx

ORDER BY 
s.a_keeper_idx

Find


Messages In This Thread
[No subject] - by kixtzz - 09-18-2013, 03:26 PM
[No subject] - by Wizatek - 09-18-2013, 03:49 PM
[No subject] - by kixtzz - 09-18-2013, 04:00 PM
[No subject] - by luoo - 09-18-2013, 04:12 PM
[No subject] - by Wizatek - 09-18-2013, 04:42 PM
[No subject] - by kixtzz - 09-18-2013, 05:11 PM
[No subject] - by kixtzz - 09-20-2013, 11:57 PM
[No subject] - by Paramount - 09-21-2013, 12:43 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)