roeya
Posts: 181
|
| Posted: 12/05/2005, 1:14 PM |
|
Can I change the syntax of table joining from
SELECT *
FROM (cities LEFT JOIN city_aliases ON
cities.id = city_aliases.id) LEFT JOIN city_phones ON
cities.id = city_phones.city_id
To
SELECT *
FROM
cities
LEFT JOIN city_aliases ON cities.id = city_aliases.id
LEFT JOIN city_phones ON cities.id = city_phones.city_id
The first sysntax is not compatible with my database
the second is OK,
I know I can do custom SQL but it takes more time to create and debug and has less flexible sorting
_________________
http://www.infoneto.com/ |
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 12/05/2005, 9:52 PM |
|
If I have a complex query to create I usually either write it down (one or more times) and or create it within the database itself (database design tool) in order to help me determine if it is allowed. From there I then cut and paste or I recreate the query using the query design tool in CCS.
Sometimes it is worth the effort to recreate the query outside of CCS before you actually use it inside CCS.
Just a thought.
|
|
|
|
roeya
Posts: 181
|
| Posted: 12/05/2005, 11:43 PM |
|
I am not talking about complex query I am talking about simple master table query with 3-4 tables that should be joined.
Anyway I checked CCS installation and found that every database type has joinSyntax, joinType definitions, my is configured as
joinSyntax="JOIN"
joinType="Simple"
however it behaves the same as joinType="Default"
maybe someone from yessoftware can check it ? I have already contacted support
_________________
http://www.infoneto.com/ |
|
|
|
roeya
Posts: 181
|
| Posted: 12/06/2005, 12:53 PM |
|
There is some work around for the join problem - view
define the join query as view , after that you can use the view like a table.
The only problem is that SQLite decide that all the fields are numeric, so you must manually change the type of every field...
P.S.
The support team is working on my request.
_________________
http://www.infoneto.com/ |
|
|
|
