subselect
|
subselect
|
09-18-2013, 04:12 PM
t_shopitem s, t_item i, t_npc n SELECT s.a_keeper_idx as npcid, n.a_name_usa as npcname, i.a_name_usa as itemname, i.a_price FROM emunew_data.t_shopitem s, test_data.t_item i, test_data.t_npc n WHERE s.a_item_idx = i.a_index change emunew_data and test_data to your database names |
|
« Next Oldest | Next Newest »
|
| 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
|
