SQL CE 3.5 - Select field from another table

SQL CE 3.5 - Select field from another table

References

Reference NO 1

http://stackoverflow.com/questions/15203876/sql-ce-3-5-select-field-from-another-table

Reference NO 2

http://stackoverflow.com/questions/1941619/nested-select-clause-in-sql-compact-3-5

Reference NO 3

http://blog.sqlauthority.com/2011/10/02/sql-server-ce-list-of-information_schema-system-tables/

Reference NO 4

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/e3f7f07c-cb0f-4d74-a612-4b7fa152826f/action?threadDisplayName=sql-server-ce-35-update-with-subquery

Reference NO 5

http://technet.microsoft.com/en-us/library/ms174854.aspx

Reference NO 6

http://technet.microsoft.com/en-us/library/ms173393.aspx

Reference NO 7

#EANF#

Reference NO 8

#EANF#