subselect
#5

s n i are just like shortcuts defined in the FROM section. U could also write it like this

 

SELECTt_shopitem.a_keeper_idx as npcid,t_npc.a_name_usa as npcname,t_item.a_name_usa as itemname,t_item.a_priceFROMt_shopitem,t_item,t_npcWHEREt_shopitem.a_item_idx = t_item.a_indexANDt_npc.a_index = t_shopitem.a_keeper_idx



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)