ÎÒÏÖÔÚÓÐÁ½¸ö±í
µÚÒ»¸ö±íΪ
id title content
1 34234 234234
µÚ¶þ¸ö±íΪ
id Tcontent time tab1ID
1 ¼ÎÁê½ 2009-1-1 1
ÔõÑù°Ñ±í¶þµÄtime¼ÓÈë±íÒ» È»ºóselectÅųötimeµÄÉýÐò
ÎÒÁ¬½ÓÁ½±í¶¼¸ãÔÎÁË Çë´ó´óÃǰï°ïæ
SQL code:
select *
from µÚÒ»¸ö±í a ,µÚ¶þ¸ö±í b
where a.id=b.tab1ID
order by b.time
SQL code:
select *
from µÚÒ»¸ö±í a inner join µÚ¶þ¸ö±í b on a.id=b.tab1ID
order by b.time
select *
from A1 a inner join A2 b on a.id=b.tab1ID
order by b.time
select a.*,b.time
from a , b
where a.id=b.tab1ID
order by b.time
select a.*,b.time
from ±í1 a inner join ±í2 b on a.id=b.tab1id
order by b.time
ÒÔÉÏ·½·¨¿ÉÒÔ²é³ö µ«ÊÇÈç¹û±í2ûÓмǼ ²éѯµÄ½á¹ûÊÇ¿Õ
ÓÐûÓа취²é³öÈç¹ûb.timeΪ¿Õ×Ô¶¯¼ÓÉÏ¡°¿Õ¡± È»ºó±í1µÄ¼Ç¼ÒÀÈ»ÏÔʾ°¡¡£¸÷λ°ï°ï棡£¡
Ïà¹ØÎÊ´ð£º
ÎÒÏÖÔÚÊÖÍ·ÓÐÕâôһ¸öÎÊÌ⣬ÎÒÏëÈÃÒ»¸ö²Ù×÷sqlite3µÄ³ÌÐòÔÚÒ»¸öARM°å×ÓÉÏÅÜÆðÀ´£¬°å×ÓÉϵÄosÊÇwince5.0¡£
ÎÒÊÇÕâô×öµÄ£¬ÎÒÏÈ´Ósqlite3Ö÷Ò³ÏÂÔØÔ´ÂëÏÂÀ´£¬ÓÐÕâô3¸öÎļþ£ºsqlite3.c¡¢sqlite3.h¡¢sqlite3ext.h £¬ ......
ÎÒÏë×öÒ»¸ösqliteµÄ¼à¿ØÈí¼þ£¬ÊµÊ±ÖªµÀÓû§¶ÔÊý¾Ý±í¶¼×öÁËÄÄЩ²Ù×÷¡£
ÔÚÓû§update Ò»¸öÓû§Êý¾Ý±íֵʱ£¬ÎÒÈçºÎ¿ÉÒÔµÃÖªÓû§updateµÄÄĸö×ֶεÄÖµ£¿ÎÒ±¾À´¸øÓû§±íÌí¼Ó´¥·¢Æ÷À´ÊµÏֵ쬵«´¥·¢Æ÷ºÃÏñÖ»Äܵõ½Ó ......
³ÌÐò´úÂëÈçÏ£º
sqlTime = "select SUM(onlineTimeSpan) from T_OnlineTimeSum where ipAddress = :a AND onlineDate BETWEEN :b AND :c";
  ......
XML code:
<?xml version="1.0" encoding="utf-8"?>
<mx:WindowedApplication xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute">
<mx ......