Using OpenRowSet Transact SQL, I want to view/obtain data from MySql
using this function in "MS SQL Query Analyzer". Can I do this at all?
I have MyODBC driver and the relevant OLE DB provider to connect to
MySQL db, I can connect to MySQL db, but having problem with the last
parameter (table nam
Running the command:
Drop table if exists table1
complaints of table1 does not exist (Error: 1051).
However, if table1 is swapped with another table, irrespective of its
existence it works just fine.
Running a Show Table command lists table1 as an existing table and
trying to create table1 complai
Using this tool (VeriTas Backup Exec for windows server v9.1) to backup the
database crashes MySQLd-nt, has anyone else come across this issue at all?
regards
3 tables:
table1 -> table2 (one to many)
table2 -> table3 (one to one) [designed like this]
how to achieve this?
select table1.*, table2.*, table3.*, sum(table2.field3), sum(table2.field4)
from table1, table2, table3 where table1.field1 = table2.field1 and
table2.field1 = table3.field1
regards
