Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Miva [join tables]

Status
Not open for further replies.
dennydeaton

dennydeaton

Programmer
Oct 17, 2002
1
US
I have three tables [xbase] that need to "join" on a common id. How can I do this in Miva Script? Please include examples if possible. Here is a rough layout.

3 tables:
Categories.dbf
Products.dbf
CatxProd.dbf

I want to sort by the Id, ParentId in Categories, then pull back ProdId's from CatxProd that has the CatId specified for each Category, then finally pull back the data from Products where ProdId is EQ to the ProdId for each record in the CatxProd.

Thanks!
denny
 
Status
Not open for further replies.

Similar threads

jvbahnik
  • Locked
  • Helpful tip
Looking for MIVA Merchant 5 Beta Testers
Replies
0
Views
34
jvbahnik
jvbahnik
jhyshark
  • Locked
  • Question
Member Discount on MIVA orders?
Replies
1
Views
51
netblazon
netblazon
CatPlus
  • Locked
  • Question
Miva - Exporting CSV files
Replies
0
Views
37
CatPlus
CatPlus
mortimier321
  • Locked
  • Question
generic gateway miva merchant
Replies
0
Views
36
mortimier321
mortimier321
macrat7
  • Locked
  • Question
Additional Liscense Key Setup Miva 4.20
Replies
0
Views
39
macrat7
macrat7

Part and Inventory Search

Sponsor

Back
Top