I've long hoped for SQL in Excel. I installed this the other day and agree dealing with the quotes is maddening. I think it would be tough to write anything complex without the help of the auto complete and function highlighting that an actual SQL editor provides, but for something simple you can get the results right on your worksheet without having to deal with exporting and importing CSVs from an SQL editor. Pretty cool, thanks for the video on how to use it. Subscribed.
I'm not a SQL expert, but if you have two tables with the same headers, you can use an inner join. Let's say your tables are called Customers and Orders and both have a field with the same data called Customer #. Try something like this: =SQLOOKUP("select [First Name] from Customers", "Customers", "select [order #] from Orders", "Orders", "inner join Customers on Customers[Order #] = Orders[Order #]") You might need to tweak the syntax.
I've long hoped for SQL in Excel. I installed this the other day and agree dealing with the quotes is maddening. I think it would be tough to write anything complex without the help of the auto complete and function highlighting that an actual SQL editor provides, but for something simple you can get the results right on your worksheet without having to deal with exporting and importing CSVs from an SQL editor. Pretty cool, thanks for the video on how to use it. Subscribed.
wow just wow
how to union two tables with same table headings?
I'm not a SQL expert, but if you have two tables with the same headers, you can use an inner join. Let's say your tables are called Customers and Orders and both have a field with the same data called Customer #. Try something like this:
=SQLOOKUP("select [First Name] from Customers", "Customers", "select [order #] from Orders", "Orders", "inner join Customers on Customers[Order #] = Orders[Order #]")
You might need to tweak the syntax.