Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › MySQL vs MSSQL - having real problems with INNER JOIN

MySQL vs MSSQL - having real problems with INNER JOIN

Thread began 1/08/2014 9:07 am by Nathon Jones Web Design | Last modified 1/09/2014 11:47 am by Nathon Jones Web Design | 3923 views | 8 replies

1/08/2014 10:11 amNathon Jones Web Design

good advice, as ever

Thank you Jason.

I've installed and configured HeidiSQL but, unlike SQL Server Management Studio, I can't easily see how I add tables to create a View, which is how I'm creating this INNER JOIN query. In SQLSMS I can simply select, from a list, all of the tables I want to use in my query (A view is just another name for a query table, right?). Where, in HeidiSQL, is the visual builder?

Thank you again for all your help Jason. My intention is to purchase eCart in the next month or two and really push on with developing in PHP.
I only hope that it, too, doesn't die like Classic ASP did.

Oh, and with that in mind, is there an upgrade option for eCart? I'm currently using version 4.5.2.

Much appreciated.
NJ

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.