目前,我使用Bigquery中的视图将两个查询拼接在一起。我想知道是否有一种方法可以将它们组合成一个查询,从而消除对多个视图的需求。
第一个查询连接几个字符串以创建"id“字段。SELECT *, CONCAT(CAST(ga_sourcemedium AS string), CAST(ga_campaign AS string), CAST(ga_adcontentstring), CAST(ga_devicecategory AS string), CAST(ga_date AS string)
Select * from Employee where (Name= 'XXXX' and age = 30) OR (Name = 'YYYY' or age = 40);Select * from Employee where Name in ('XXXX','YYYYY') AND age in (30,40);
显然给出了错误的结果。
$db) die("Error connecting to MySQL database.");
mysql_select_db("sync" ,$db);$result = mysql_query("SELECT DISTINCT `name`,`password`,INET_NTOA( `ip` ) FROM detail Where id = '$_GET["name"]' ;&