`

outer or full join must be followed by path expression

阅读更多

我只做了两个表的简单的ID的关联
sql 如下  select media.mediaName,media.mediaId from Media media join MediaIcp mc on  media.mediaId=mc.mediaId  where mc.mediaChannelid=1
结果报错
如下: outer or full join must be followed by path expression
google了一下有的说hql不支持 on ,但看了几个文档明显的写着支持join的 ,到最后也没找到个真正的原因和解决办法,谁能给解释一下并给出解决方法。

分享到:
评论

相关推荐

    微软内部资料-SQL性能优化5

    On a qualified select, update, or delete, the correct leaf page will be the lowest page of the tree in which one or more rows with the specified key or keys reside. A qualified operation is one that ...

    Tajima 绣花机 花型数据编码格式

    All entries in the header seem to be 2 ASCII characters followed by a colon, then it’s value trailed by a carriage return. First is the ‘LA’ entry, which is the design name with no path or ...

    【原创】【源代码】myshell:操作系统编程-自己用C语言写的Linux下的Shell

    echo <comment> - display <comment> on the display followed by a new line (multiple spaces/tabs may be reduced to a single space) help - display the user manual using the more filter pause - pause ...

    MAXQ1850 USB-HID 范例 内有SPI watchdog 代码可供参考 C 代码 编译环境cross studio

    This project has a few special settings that must be followed. 1. Create a new project as shown in section D of the main README.txt 2. Under "Project Explorer" in the upper right corner open the ...

    fx-570_991ES_PLUS_EN

    根据提供的文件信息,我们可以深入探讨fx-570ES PLUS与fx-991ES PLUS这两款计算器的相关功能和操作指南。以下是对标题、描述、标签以及部分内容中的关键知识点进行的详细解读: ### 一、产品简介 ...

    skyhigh.zip

    The device supports the ONFI Read Parameter Page operation, initiated by writing ECh to the Command Register, followed by an address input of 00h. The host may monitor the R/B# pin or wait for the ...

    2009 达内Unix学习笔记

    集合了 所有的 Unix命令大全 ...telnet 192.168.0.23 自己帐号 sd08077-you0 ftp工具 192.168.0.202 tools-toolss ... 各个 shell 可互相切换 ksh:$ sh:$ csh:guangzhou% bash:bash-3.00$ ... 命令和参数之间必需用空格隔...

    Keil MDK 编译 ucOS-II 出现的警告和错误解决

    在编译过程中,可能会出现警告 A1085W:Forced user-mode LDM/STM must not be followed by use of banked R8-R14。这是因为编译器检测到强制用户模式的 LDM/STM 指令可能会导致 R8-R14 寄存器的不正确使用。解决...

    小雨伞环境文件

    # be placed in the first column followed by the corresponding host name. # The IP address and the host name should be separated by at least one # space. # # Additionally, comments (such as these) may ...

    3000正则表达式

    that is, the submask must start with a 1 bit followed by 0 or more 1 bits, followed by 1 or more 0 bits until the end of the submask. 10 | 110 | 1100 ^([1][12]|[0]?[1-9])[\/-]([3][01]|[12]\d|[0]?[1-9...

    abb 变频器canopen使用说明

    This chapter states the general safety instructions that must be followed when installing and operating the RCAN-01 CANopen Adapter module. The material in this chapter must be studied before ...

    山东航天电子技术研究所计算机中心机房建设的进度管理研究.doc

    By integrating advanced methodologies like critical path management and focusing on collaboration and process standardization, the efficiency and success of such projects can be significantly ...

    PowerCommands for Visual Studio 2008

    This command copies the full path of the currently selected item to the clipboard. It can be executed by right-clicking one of these nodes in the Solution Explorer: The solution node; A project node; ...

    uhdd.sys源码

    in CONFIG SYS or it can load later in AUTOEXEC BAT or by user command DOS can copy critical programs and data to the RAMdisk where they will be read or written at memory speed If loaded after ...

    eda-playground-readthedocs-io-en-latest.zip

    Log in. Click the Log in button (top right) Then either click on Google or Facebook or ...(Note: The code in the right Design pane is compiled first, followed by code in the left Testbench pane.)

    Google C++ Style Guide(Google C++编程规范)高清PDF

    To guarantee uniqueness, they should be based on the full path in a project's source tree. For example, the file foo/src/bar/baz.h in project foo should have the following guard: #ifndef FOO_BAR_BAZ...

    cucu-a compiler you can understand

    The grammar specifies the structure and syntax rules that must be followed by the source code. In the case of CUCU, the grammar is defined using Extended Backus-Naur Form (EBNF), which is a notation ...

    poj 1003 Hangover

    (We're assuming that the cards must be perpendicular to the table.) With two cards you can make the top card overhang the bottom one by half a card length, and the bottom one overhang the table by a ...

    Learning Phalcon PHP(PACKT,2015)

    Phalcon is a full-stack ... Phalcon is loosely coupled, allowing you to use its objects as glue components based on the needs of your application.... ... You will begin the journey by installing and setting up...

Global site tag (gtag.js) - Google Analytics