Help me asap... I need this for my exam

[freelance_jhoe26]

Using SQL STATEMENT, create a script that will relate tables



I know the basic sql statements but this is the first time I encountered sql statement that will relate tables ...


answers will be very much appreciated ..




here is my sample scenario


Using SQL Statement I need to relate the 2 tables






cat_tab with fields catid, catdesc


item_tab with fields itemId, itemDesc, catId <catId is the foreign key to relate with cat_tab>


please help me!!!! :'(

[rustyCrVx]

I'm no pro but I saw nobody had answered you.
Are you saying you're supposed to use a sql statement to create the relationship between the two tables? Or are you perhaps supposed to use a sql to gather information from the two tables?