# FlinkSQL Lookup Join支持PROCTIME()语法
#### 使用场景
Flink Lookup Join语法中要求FOR SYSTEM_TIME AS OF包含proc_time字段，例如FOR SYSTEM_TIME AS OF o.proc_time。现在可以使用PROCTIME()代替表中的proc_time字段，直接使用FOR SYSTEM_TIME AS OF PROCTIME()，表中不需要再定义proc_time字段。子查询也适用。
#### 使用方法
配置Flink作业时，Lookup Join可以直接使用PROCTIME()来代替表中proc_time字段。
#### SQL示例
```
CREATE TABLE kafkasource(
  order_id STRING,
  price DECIMAL(32, 2),
  currency STRING
) WITH (
  'connector' = 'kafka',
  'topic' = 'test_source',
  'properties.bootstrap.servers' = 'Kafka的Broker实例业务IP:Kafka端口号',
  'properties.group.id' = 'testGroup',
  'scan.startup.mode' = 'latest-offset',
  'format' = 'csv'
);
CREATE CATALOG lf_paimon_catalog WITH (   'type' = 'paimon',   'metastore' = 'lakeformation' );
CREATE TABLE lf_paimon_catalog.paimon_db.paimon_table (id STRING, name STRING, country STRING);
CREATE TABLE print (
  order_id STRING,
  price DECIMAL(32, 2),
  name STRING,
  country STRING
) WITH ('connector' = 'print');
insert into
  print
SELECT
  o.order_id,
  o.price,
  c.name,
  c.country
FROM
  kafkasource as o
  JOIN lf_paimon_catalog.paimon_db.paimon_table FOR SYSTEM_TIME AS OF PROCTIME() AS c ON o.order_id = c.id;
```
