Join tables in search

[Jamil Jamal]

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.
Thanks.

[navaldesign]

Re: Join tables in search

Sorry, you can't Soho only allows for a search in one table at a time.

[Jamil Jamal]

Re: Join tables in search

Thanks,
Sorry, i am begginer in this "world".
Can i do it outside soho?
How?

[navaldesign]

Re: Join tables in search

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.