View Full Version : Join tables in search

Jamil Jamal
08-21-2006, 12:08 AM
Hello Everybody,

I am using soholunch and MySql, and i don't know how to create a search in two diferent tables in the same search.

I have a same name field in both tables.

What i need is get information from second table fields, in the same search.

I am trying to avoid redundance data in the database.

08-21-2006, 07:14 AM
Sorry, you can't Soho only allows for a search in one table at a time.

Jamil Jamal
08-21-2006, 10:10 AM
Sorry, i am begginer in this "world".
Can i do it outside soho?

08-21-2006, 10:59 AM
Yes, but with a custom made, external script. I don't think you want to mess with your shopping cart database tables with an external script.