How to run SQL query using the joined DataTable

[Daniel]

Hello Everyone,


There are 3 DataTables.


1. From Google SpreadSheet.
2. From Google SpreadSheet.
3. Joined Table from 1 and 2 Tables.


However, I want to run SQL query using the third joined table.


Can I use the joined DataTable object as data source of SQL query ?



Thanks in advance.
Bye,

[ChartMan]

If you join the tables to a spreadsheet you can query it with google.visualization.Query and use the library built in SQL-like query language.

HTH
ChartMan

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To post to this group, send email to google-visua...@googlegroups.com.
To unsubscribe from this group, send email to google-visualizati...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.

[asgallant]

Can you query a DataTable object?  No.  Depending on exactly what you want, you might be able to use DataViews to sort, filter, and manipulate the contents of a DataTable in a manner similar to a query (though you wouldn't have SQL-esque capabilities without extensive custom code).