
Originally Posted by
Royalblade
In Vb you've got Linq.. meaning you got linq queries, I believe..
VB linq should be smtn like that
dim q = from items in _items
join inventory in _inventory on items.id64 equals inventory.itemid
select items.magparamnum
SQL - This wouldn't really work since you'd have to select TOP 1 or smtn... but just as an example... even tho linq is for lists and shit but eh.. gotta prove a point xD
SELECT @q = magparamnum
from _Items as items
join _Inventory as inventory on items.id64 = inventory.itemid
Does that not look exactly the same?